Previous Topic

Next Topic

Controlling Joins Between Filters

When you define multiple filters, by default they join using "AND", which narrows the results.

However, if you add multiple filters on the same object Property (such as StateProvince), by default the filters join with an "OR" connective, which broadens the results.

Therefore, to use the same object Property in an "AND" join, you need to create those filters separately.

For example, to define a filter to obtain customer records in Texas AND in Virginia, first create one filter (where StateProvince = TX) and then select Add Filter to define the second part (where StateProvince = VA).

See Also

Adding a Filter

Tips for adding filters

Entering Values for Comparison

Filter Options for Advanced Mode

Defining multiple values for a filter property


ASI logo 10.6 Production Release. Updated 7/27/2006 3:52:54 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.